Query: SELECT enStrId FROM products WHERE StrId='Acer platanoides 'Rákóczi út'' failed. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Rákóczi út''' at line 1<br>
<hr>
(mysqli): SELECT enStrId FROM products WHERE StrId='Acer platanoides 'Rákóczi út'' &nbsp; 
<hr>
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Rákóczi út''' at line 1<br>
Query: 

    SELECT SQL_CALC_FOUND_ROWS
                products.*,
				(SELECT StrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatStrId,
				(SELECT Title FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatTitle,
				(SELECT enStrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatStrId,
				(SELECT enTitle FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatTitle,
				img.Id AS ImgId,
				CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath,
				CONCAT( '/attachment/', IF( img2.DirectoryPath IS NULL, '', CONCAT( img2.DirectoryPath, '/' ) ), img2.Id, '_', img2.FileName ) AS ImgPath2,
				CONCAT( '/attachment/', IF( img3.DirectoryPath IS NULL, '', CONCAT( img3.DirectoryPath, '/' ) ), img3.Id, '_', img3.FileName ) AS ImgPath3,
				img.Name AS ImgName,
				
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=1) AS Prod1,
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=2) AS Prod2,
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=3) AS Prod3,
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=4) AS Prod4

    FROM
                products
				
	LEFT JOIN product_image ON product_image.ProductId = products.Id
	LEFT JOIN attachments AS img ON img.ParentId = product_image.AttachmentId AND img.CopyId = 1
	LEFT JOIN attachments AS img2 ON img2.ParentId = product_image.AttachmentId AND img2.CopyId = 2
	LEFT JOIN attachments AS img3 ON img3.ParentId = product_image.AttachmentId AND img3.CopyId = 3
	
	WHERE
		products.Id = 
		AND
        products.Deleted IS NULL 
	GROUP BY 
		products.Id
	ORDER BY 
		SortBy ASC
	
	 failed. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND
        products.Deleted IS NULL 
	GROUP BY 
		products.Id
	ORDER BY 
		S...' at line 28<br>
<hr>
(mysqli): 

    SELECT SQL_CALC_FOUND_ROWS
                products.*,
				(SELECT StrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatStrId,
				(SELECT Title FROM product_categories WHERE product_categories.Id=products.CategoryId) AS ProdCatTitle,
				(SELECT enStrId FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatStrId,
				(SELECT enTitle FROM product_categories WHERE product_categories.Id=products.CategoryId) AS enProdCatTitle,
				img.Id AS ImgId,
				CONCAT( '/attachment/', IF( img.DirectoryPath IS NULL, '', CONCAT( img.DirectoryPath, '/' ) ), img.Id, '_', img.FileName ) AS ImgPath,
				CONCAT( '/attachment/', IF( img2.DirectoryPath IS NULL, '', CONCAT( img2.DirectoryPath, '/' ) ), img2.Id, '_', img2.FileName ) AS ImgPath2,
				CONCAT( '/attachment/', IF( img3.DirectoryPath IS NULL, '', CONCAT( img3.DirectoryPath, '/' ) ), img3.Id, '_', img3.FileName ) AS ImgPath3,
				img.Name AS ImgName,
				
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=1) AS Prod1,
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=2) AS Prod2,
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=3) AS Prod3,
				(SELECT Id FROM product_prodtab WHERE product_prodtab.ProductId=products.Id AND product_prodtab.ProdtabId=4) AS Prod4

    FROM
                products
				
	LEFT JOIN product_image ON product_image.ProductId = products.Id
	LEFT JOIN attachments AS img ON img.ParentId = product_image.AttachmentId AND img.CopyId = 1
	LEFT JOIN attachments AS img2 ON img2.ParentId = product_image.AttachmentId AND img2.CopyId = 2
	LEFT JOIN attachments AS img3 ON img3.ParentId = product_image.AttachmentId AND img3.CopyId = 3
	
	WHERE
		products.Id = 
		AND
        products.Deleted IS NULL 
	GROUP BY 
		products.Id
	ORDER BY 
		SortBy ASC
	
	 &nbsp; 
<hr>
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND
        products.Deleted IS NULL 
	GROUP BY 
		products.Id
	ORDER BY 
		S...' at line 28<br>
Query: SELECT 
		attachments.Id AS ImgId,
        CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath,
		CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+1), '_', REPLACE(attachments.FileName,'copy_2','copy_3') ) AS NImgPath,
        attachments.Name AS ImgName,
		attachments.Width AS ImgWidth
		FROM
		attachments
		WHERE 
		CopyId=2 
		AND 
		ParentId=(SELECT Id FROM attachments WHERE attachments.CopyId IS NULL
			AND
			attachments.PrimePic=1
			AND
			attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = ))
		
		GROUP BY attachments.Id
		LIMIT 1
		 failed. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
		
		GROUP BY attachments.Id
		LIMIT 1' at line 16<br>
<hr>
(mysqli): SELECT 
		attachments.Id AS ImgId,
        CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath,
		CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+1), '_', REPLACE(attachments.FileName,'copy_2','copy_3') ) AS NImgPath,
        attachments.Name AS ImgName,
		attachments.Width AS ImgWidth
		FROM
		attachments
		WHERE 
		CopyId=2 
		AND 
		ParentId=(SELECT Id FROM attachments WHERE attachments.CopyId IS NULL
			AND
			attachments.PrimePic=1
			AND
			attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = ))
		
		GROUP BY attachments.Id
		LIMIT 1
		 &nbsp; 
<hr>
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
		
		GROUP BY attachments.Id
		LIMIT 1' at line 16<br>
Query: SELECT 
		attachments.Id AS ImgId,
        CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath,
		CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+2), '_', REPLACE(attachments.FileName,'copy_1','copy_3') ) AS NImgPath,
        attachments.Name AS ImgName,
		attachments.PrimePic AS PrimePic
		FROM
		attachments
		WHERE 
		CopyId=1 
		AND 
		ParentId IN (SELECT Id FROM attachments WHERE attachments.CopyId IS NULL
			AND
			attachments.PrimePic IS NULL
			AND
			attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = ))
		
		GROUP BY attachments.Id
		 failed. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
		
		GROUP BY attachments.Id' at line 16<br>
<hr>
(mysqli): SELECT 
		attachments.Id AS ImgId,
        CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS ImgPath,
		CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), (attachments.Id+2), '_', REPLACE(attachments.FileName,'copy_1','copy_3') ) AS NImgPath,
        attachments.Name AS ImgName,
		attachments.PrimePic AS PrimePic
		FROM
		attachments
		WHERE 
		CopyId=1 
		AND 
		ParentId IN (SELECT Id FROM attachments WHERE attachments.CopyId IS NULL
			AND
			attachments.PrimePic IS NULL
			AND
			attachments.Id IN (SELECT AttachmentId FROM product_image WHERE ProductId = ))
		
		GROUP BY attachments.Id
		 &nbsp; 
<hr>
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
		
		GROUP BY attachments.Id' at line 16<br>
Query: SELECT 
		attachments.Id AS DocId,
        CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS DocPath,
		attachments.Name AS DocName,
		attachments.enName AS enDocName
		FROM
		attachments
		WHERE 
		ParentId IS NULL
		AND
		attachments.Id IN (SELECT AttachmentId FROM product_document WHERE ProductId = )
		GROUP BY attachments.Id
		 failed. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
		GROUP BY attachments.Id' at line 11<br>
<hr>
(mysqli): SELECT 
		attachments.Id AS DocId,
        CONCAT( '/attachment/', IF( attachments.DirectoryPath IS NULL, '', CONCAT( attachments.DirectoryPath, '/' ) ), attachments.Id, '_', attachments.FileName ) AS DocPath,
		attachments.Name AS DocName,
		attachments.enName AS enDocName
		FROM
		attachments
		WHERE 
		ParentId IS NULL
		AND
		attachments.Id IN (SELECT AttachmentId FROM product_document WHERE ProductId = )
		GROUP BY attachments.Id
		 &nbsp; 
<hr>
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
		GROUP BY attachments.Id' at line 11<br>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="hu" xml:lang="hu">
<head profile="http://gmpg.org/xfn/11">
    <title>Növények - Biota Szolgáltató és Oktató Bt.</title>
    <meta http-equiv="content-type" content="text/html; charset=utf-8" />
    <link rel="shortcut icon" type="image/x-icon" href="/favicon3.png" /> 
    
	
	<link rel="stylesheet" type="text/css" href="/css/default.css" />
	
	
	<link rel="stylesheet" type="text/css" href="/css/comments.css" />
    <!--[if IE 6]><link rel="stylesheet" type="text/css" href="/css/ie6.css" /><![endif]-->
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
    <script type="text/javascript" src="/javascript/default.js"></script>
		<meta name="keywords" content="biota, növényfotó"/>
	<meta name="description" content="biota, növényfotó"/>
	<script type="text/javascript" src="/javascript/fontsize.js"></script>
	
	<link href="/css/pirobox.css" class="piro_style" media="screen" title="white" rel="stylesheet" type="text/css" />
	<script type="text/javascript" src="/javascript/pirobox.js"></script>
	<script type="text/javascript">
	$(document).ready(function() {
		$().piroBox({
				my_speed: 400, //animation speed
				bg_alpha: 0.1, //background opacity
				slideShow : true, // true == slideshow on, false == slideshow off
				slideSpeed : 4, //slideshow duration in seconds(3 to 6 Recommended)
				close_all : '.piro_close,.piro_overlay'// add class .piro_overlay(with comma)if you want overlay click close piroBox

		});
	});
	</script>
	
	<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-29852356-1']);
  _gaq.push(['_trackPageview']);
  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
</script> 
</head>
<body marginwidth="0" marginheight="0">
<div id="all">


	<div id="menu">
			<ul><li id="mm0"  class="mp" ><a href="/bemutatkozas">Bemutatkozás</a></li><li class="mpsep"></li><li id="mm1"  class="mp" ><a href="/termekek">Termékek</a></li><li class="mpsep"></li><li id="mm2"  class="mp" ><a href="/szallitasi_feltetelek">Szállítási feltételek</a></li><li class="mpsep"></li><li id="mm3"  class="mp" ><a href="/megrendeles">Megrendelés</a></li><li class="mpsep"></li><li id="mm4"  class="mp" ><a href="/kapcsolat">Kapcsolat</a></li><li class="mpsep"></li><li id="mm5"  class="mp" ><a href="/referenciak">Referenciák</a></li></ul>
	</div>
	<div id="balpanel">
		<div id="logo"><a href="/"><div style=" width: 340px; height: 246px;"></div></a></div>
				<div id="kereso">Növénykereső
			<div class="kereses">
				<form method="post" action="/kereses/" id="searchpageform">
				<div id="form">
					<input type="text" name="qstr" value=""><input type="submit" value="keresés">
				</div>
				</form>
			</div>
		</div>					<div id="ajanlo">
			<a href="/novenyek/lombosok/ulmus_elegantissima_jacqueline_hillier"><img src="/attachment/0001/3277_copy_1_14760_ulmus_elegantissima_jacqueline_hillier.jpg"></a>
			<h3><a href="/novenyek/lombosok/ulmus_elegantissima_jacqueline_hillier">Ulmus elegantissima ’Jacqueline Hillier’</h3>
			<!--i>Syringa vulgaris</i><br-->
			<span class="bullet"> cikkszám: 147600</span>
			<br><a href="/megrendeles" class="ns">Tovább a megrendelés oldalra</a>
			</div>
			</div>
	
	<!-- főoldal -->
   	<div id="main">
	<div style="width: 150px; position: absolute; left: 555px; top: 35px; "><a href="#"><img src="/images/design/hu.png"></a> <a href="/laubgeholze//de"><img src="/images/design/de.png"></a></div>
	 <div style="margin: 35px 50px 20px 50px">						
					<br><br>
	 </div>	<br><br>
						

	</div>
	<div class="clearer"></div>
			
        
	<!-- főoldal vége -->
    <div id="lablec">
		BIOTA Szolgáltató és Oktató Bt. &copy; 2011 | Minden jog fenntartva!
	</div>
</div>

</body>
</html>